This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Data Upload:
Drop your file here or click to browse
Project Name/Subject:
Email Form to:
Tell Us About Your Building and Service Requirements
Cooling
Functional Use =
Select
Office
Hotel
Event
Other
Cost of Capital =
Water-Cooled Condensers with Cooling Towers? =
YES
YES
NO
Required
Sq ft/ton =
Conditioned Space (sq ft) =
Load Factor =
Self-Generation Cooling Costs Estimate:
Demand =
tons
Annual Consumption =
tonhrs
Installed Capacity =
tons
Building Area Required =
sq ft
Total Utility Cost =
per year
Total Other O&M Cost =
per year
Annualized Capital Cost =
per year
Total Cooling Cost =
per year
Avgerage Unit Cost =
per tonhr
Estimated CHW from DES =
per year
Avgerage DES Unit Cost =
per tonhr
Estimated Savings with DES Chilled Water Service =
per year
Tell Us About Your Building and Service Requirements
Heating
Functional Use =
Select
Office
Hotel
Event
Other
Cost of Capital =
100% Electric Heat? =
No
NO
YES
Required
BTU/sq ft =
Conditioned Space (sq ft) =
Load Factor =
Self-Generation Heating Costs Estimate:
Demand =
pph Stm (or mBTU)
Annual Consumption =
Lbs Stm (or mBTU)
Installed Capacity =
pph (or MBTU)
Building Area Required =
sq ft
Total Utility Cost =
per year
Total Other O&M Cost =
per year
Annualized Capital Cost =
per year
Total Heating Cost =
per year
Avgerage Unit Cost =
per MBTU
Estimated Steam from DES =
per year
Avgerage DES Unit Cost =
per MBTU
Estimated Savings with DES Steam Service =
per year
Cooling Data Calculation:
1 = Hide
Electricity Used =
kWhr/yr
Total Water Usage =
100 cubic feet/yr
Evaporation =
100 cubic feet/yr
Sewer Usage =
100 cubic feet/yr
Chiller Plant Area =
sq ft
Cooling Tower/Condenser Area =
sq ft
Total Electric Cost =
per year
Total Water/Sewer Cost =
per year
Total Water Treatment Cost =
per year
Total Maintenance Cost =
per year
Total Equipment/Install Cost =
Total Cost of Space =
Total Capital Cost =
Annualized Capital Cost =
per year
Total Cooling Cost =
per year
Unit Cooling Cost =
per tonhr
Estimated Costs with services from DES
Estimated Cost of CHW =
per year
Estimated Unit Cost of CHW =
per tonhr
Heating Data Calculation:
Electricity Used =
kWhr/yr
Natural Gas Used =
mmBTU/yr
Boiler Plant Area =
sq ft
Condenser Area =
sq ft
Total Electric Cost =
per year
Total Natural Gas Cost =
per year
Total Water Treatment Cost =
Total Maintenance Cost =
per year
Total Equipment/Install Cost =
Total Cost of Space =
Total Capital Cost =
Annualized Capital Cost =
per year
Total Heating Cost =
per year
Unit Heating Cost =
per MBTU
Estimated Costs with services from DES
Estimated Cost of Steam =
per year
Estimated Unit Cost of Steam =
per 1,000 lb or mmBTU
Major Unit Cost and Rates used in Cost Calculations
Cooling Electric; average $/kWh =
Heating Electric; average $/kWh =
Natural Gas; $/mmBTU =
Elec Use for Gas Heat; kW/mmbtu =
Elec Efficiency =
95%
95%
Nat Gas Efficiency =
70%
Air-Cooled Efficiency; kW/Ton =
95%
Water-Cooled Efficiency; kW/Ton =
95%
Water-Cooled $/Ton Installed =
Air-Cooled $/Ton Installed =
$/SF Mechanical Space =
BTU/LB Stm =
0.0430
$/LB/Hr Installed Capacity =
$/SF Mechanical Space =
Update
Reset
Print
Submit